Binary values in the database

[Poul Møller Hansen]

I'm struggling supporting national characters of different origin in a mixed
environment
using PHP, Perl and Java.

I have a database created with character set UTF-8, but I'm in doubt when
the data is stored
as UTF-8 or latin1-9 then the clients are also doing some automatic
character conversion.

For this reason I need a way to see how the data are stored in the database
without character
conversion.

Any way to see the binary/hexa decimal values ?
Thanks in advance,
Poul

[Serge Rielau]

Poul,

Just use the HEX function. It displays the data as-is. Works on pretty
much all data types.
Another thing you can do is CAST (c1 AS VARCHAR(100) FOR BIT DATA)
That will pass the data as-is to the client. (Works the other way around
on a parameter marker or host variable as well)

Cheers
Serge

[Poul Møller Hansen]

> Another thing you can do is CAST (c1 AS VARCHAR(100) FOR BIT DATA)

Thanks, the hex function works fine.
Can you help me with a proper syntax to the "FOR BIT DATA" for this
statement ?
select name from pmh.test where no = 44

Cheers,
Poul

[Serge Rielau]

Poul Møller Hansen wrote:

Thanks, the hex function works fine.
Can you help me with a proper syntax to the "FOR BIT DATA" for this
statement ?
select name from pmh.test where no = 44

select cast(name as <typeofname> FOR BIT DATA) as name from pmh.test
where no = 44

Cheers
Serge