TEXT and VARCHAR and UTF-8
Hi Everybody!
I'm trying to make my web application to work in UTF-8.
I've converted the database tables to UTF-8 (using ALTER
TABLE with CONVERT TO) and I'm using the following
connection properties for JDBC:
useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8.
When I'm looking at th resturned result set,
all VARCHAR fields are correctly sent in UTF-8 as I want.
However, the TEXT fields aren't. More interestingly- when
I'm applying the MySQL's REPLACE function on those TEXT
fields, the returned values in result set are perfect UTF-8.
What could be the problem?
Greatly appreciate any help on this!
Jaanus
Subject
Views
Written By
Posted
TEXT and VARCHAR and UTF-8
3569
October 28, 2005 04:05AM
1905
October 28, 2005 06:07AM
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.