Re: Characterset UTF8
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
Subject
Views
Written By
Posted
4181
July 24, 2010 02:11PM
1726
July 28, 2010 11:55PM
Re: Characterset UTF8
1781
July 29, 2010 03:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.