在Oracle和PHP中使用Unicode

Question

I am currently making a web application, I want to add Unicode support in my application. My application is a search based application. I store some keyword and some text in my database, and show the result according to keyword in a search query.

I am using Oracle 10g XE edition and PHP 5.

I know nothing about adding Unicode.

Answer 1

First of all, have you downloaded a version of XE which supports UNICODE? Not all of them do. Check out the XE Download page.

OTN has a white paper on Unicode in the database. It's a few years old now, but it still covers the ground. Read it now. If you need detailed information regarding implementation read the Oracle Globalization Reference.

Finally, no overview of Unicode would be complete without a link to Joel's article "The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)".