TEXT and VARCHAR and UTF-8
Posted by: Jaanus Heinlaid
Date: October 28, 2005 04:05AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
TEXT and VARCHAR and UTF-8
3448
October 28, 2005 04:05AM
1833
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.