Re: How to query a string in Hex or byte format


vwu@xxxxxxxxxxx wrote:
> Hi,
>
> I suspect the string I query is different than what it was actually
> stored in the database table since the NLS setting are different
> between the database server and the code page used for the display on
> the client machine, so how can I query a string such as a person's name
> in Hex or byte format.
>
> Thank You
> Vance

The NLS setting for the Sun OS on my Oracle client machine is en
US.ISO8859-1, my Oracle8i and Oracle9i database character sets are both
set to UTF-8, when I insert string "COFIÑO" into the 8i & 9i databases
via my Oracle client machine, on the Oracle8i I believe it
automatically converted to "COFIQO", and on the Oracle9i it converted
to "COFI¿O", the string data type is VARCHAR2.

Can someone tell me why and how to fix it?

Thanks,
Vance

.

Relevant Pages

  • Re: Location of linked table username/password
    ... I use this procedure to re-create links to Oracle. ... Public Function LinkOracleTables(strDSN As String, strSchema As Variant, ... Dim dbODBC As Database, strConnect As String, strSQL As String ... Exit Sub ...
    (microsoft.public.access.externaldata)
  • Re: Re-logging into An Oracle Database
    ... I've done it in MS SQL but never in Oracle. ... My connection string seems to work, but the app seems to keep the old userid so I can't see the tables I need to see. ... What I prefer to do is use PTQs is to run updates via VBA, something like this. ... 'no error handling included here for this post, but error procs can be included to return a false for this function of the query does not execute. ...
    (comp.databases.ms-access)
  • Re: Access and Linked tables to Oracle
    ... You might want to consider using a Pass-through query for this, ... you do not need to update your Oracle tables through Access. ... > The initial Access database was created in Access 2000. ... > is really slow if the primary key gets created on that table ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Injection Legalities
    ... I am currently writing the SANS Step-by-step guide to securing Oracle ... Oracle database, application server et al to secure it. ... >This was being discussed as a legal issue in pen-test, but I was curious if>anyone else has thought of using SQL Injection to cause a DoS. ... The second OR is>only to maintain a valid SQL statement (assuming the final character in the>query will be a single quote). ...
    (Vuln-Dev)
  • ADO exception with character combination inside string...
    ... We also have various Delphi7 programs that operate on this database. ... These programs are set up to trap the exception in an ADO operation ... and log the query text that was in use when the exception happened. ... What happens is that if we have a string to store inside the database ...
    (borland.public.delphi.database.ado)