UTF-8 impact on a database

[satish mullapudi]

Hi all,
Am using DB2 UDB v 8.2 Enterprise Edition. I have a database with code
set = UTF-8. Now I want my database to handle other data also apart
from English ie. Japanese, Spanish, German etc,etc. So, these Japanese
for ex. will be encoded as double byte character sequence while
English as Single Byte Character. Now my applications will also be
dealing with Double byte data.
1. Should I do any modifications to my database to support the same or
UTF-8 supports all formats (Western & Eastern)? If so, what are the
modifications?
2. I suppose data conversion is done when non-English data in given/
retreived. So, will there be any effect on the performance of the
database/applications accessing it?

Thanks in advance....

Awaiting ur replies....

Satish Mullapudi

[Hemant Shah]

While stranded on information super highway satish mullapudi wrote:

Hi all,
Am using DB2 UDB v 8.2 Enterprise Edition. I have a database with code
set = UTF-8. Now I want my database to handle other data also apart
from English ie. Japanese, Spanish, German etc,etc. So, these Japanese
for ex. will be encoded as double byte character sequence while
English as Single Byte Character. Now my applications will also be
dealing with Double byte data.
1. Should I do any modifications to my database to support the same or
UTF-8 supports all formats (Western & Eastern)? If so, what are the
modifications?

No, you do not need to do anything to the database, make sure that the
code page and code set on the client is the same as the server. We store
English, Spanish and Japanese characters in the same table.

2. I suppose data conversion is done when non-English data in given/
retreived. So, will there be any effect on the performance of the
database/applications accessing it?

You application must know how to handle UTF-8 characters because that is
what you will get from DB2.

>
Thanks in advance....

Awaiting ur replies....

Satish Mullapudi

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.