Hi all,
I need to save in a table a string of bytes for further treatment. This
string of bytes is saved in to the data base from a proC and Visual Basic
programs and then is retrived from the database by this programs for further
manipulation. For this purpose I have used a VARCHAR2 field. The problem
that I encounter is as follows:
1) I save a string of bytes in the table from a proC or a Visual C program.
2) PROBLEM: When I retrieve this string from the table for further treatment
I find out that some of the byte values are different from the ones that I
saved in the first place. I have found out that this happens in bytes with
certain values:
- Bytes from (hex)80 to to (hex)9H are always changed to (hex)BF
- Bytes from (hex)FB to to (hex)9H are always changed to (hex)20
I think that this has something to do with the character set used in the
oracle client and the one used in the database server, but I'm not sure how
solve the problem. I have assured myself that client and DB where using the
same character set (WE8MSWIN1252), but the problem is still there. Right now
I have:
- In the client side NLS_LANG=SPANISH_SPAIN.WE8MSWIN1252
- In the database NLS_CHARACTERSET = WE8MSWIN1252
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_RDBMS_VERSION = 9.2.0.1.0
żDoes anybody know how why this byte-changing is happening?
żDoes anybody know another data type where to store byte strings(500 bytes
at the most). I Thought of using a RAW type field, but I need to manipulate
the string (bit and byte level) and I don't know how to do that with this
data type.
Thaks in advance,
Miguel.
Received on Mon May 12 2003 - 08:16:47 CDT
