Re: Characterset UTF8

[Nico van de Kamp]

Hello,

Thanks for you're reaction.

On this moment I don't know how it is represented in csv. I understand I can see that anywhere? I will look tonight.

I'm quit new to SQL but you mean for example:
SELECT field_name
, HEX(field_name)
, length(field_name)
, char_length(field_name)
from table_x t where t.field_name = 'value';

I tried this just in TOAD with an Oracle db, but I get an error on the HEX(), and the char_length()
So, I don't if this is due TOAD/Oracle or .... I will this try tonight as well.

I don't know exactly my import query on this moment but:
is maybe the alternatif

LOAD DATA IN FILE C:\.....\xxxx.csv INTO TABLE .... CHARACTER_SET UTF-8.

I've this not tried yet, but I thought it is maybe an idea.

Nico