Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL script, UTF-8, Oracle database

 
   Database Help (Home) -> PHP SQL RSS
Next:  pokemon  
Author Message
Nico

External


Since: Nov 19, 2008
Posts: 5



(Msg. 1) Posted: Wed Nov 19, 2008 5:07 am
Post subject: SQL script, UTF-8, Oracle database
Archived from groups: alt>php>sql (more info?)

Hi, I have installed the Oracle Database 10g Express Edition Release
10.2.0.1.0 on a Linux workstation for dev purposes, along with Apache
2 and PHP5. The production environment of my customer uses Unix for
the Oracle database server, Win2003/IIS for the webserver.

Our PHP application works with UTF-8 encoded strings and actually
sends SQL INSERTS in UTF-8 format to the server. When this data is
retrieved, special foreign characters are corrupted.
I'm a bit confused, since we did not experience these problems, after
recreating the databases we do. And it is not clear to me where I
should search for the characterset related issues.

Some NLS settings:

National Language Parameter Value
NLS_CHARACTERSET AL32UTF8
NLS_COMP BINARY
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE
NLS_TERRITORY AMERICA

Example of insert:
CREATE TABLE sys_languages (
id number(12,0) NOT NULL,
descr varchar2(60) NULL,
code_int varchar2(6) NULL,
code_html varchar2(6) NULL
);
CREATE SEQUENCE sys_languages_new START WITH 7 INCREMENT BY 1;
CREATE UNIQUE INDEX sys_languages_pk on sys_languages (id);
INSERT INTO sys_languages (id, descr,code_int,code_html) VALUES
(4,'Česky',null,null);

Data is sent correctly to the server, but returns corrupted.

Questions:
- Is it possible to use ALTER SESSION to change the characterset?
- What do we need to configure in order to have the database server
and the client work with UTF-8?

Thanks in advance for your reply.

Kind regards,
Nico

 >> Stay informed about: SQL script, UTF-8, Oracle database 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Advanced wallpaper script - Advanced Wallpaper Script Advanced Wallpaper Script is a easy-to-use wallpaper hosting management system. Get your website up and running in minutes after purchase. You are interested in hosting this kind of site and having no time for uploading huge...

problems with php / database - Hi, I have problems with php / database See this: The problem is your hosting has a limitation on time of running of PHP scripts and the DB is not unpacked within this time. You should find out if your hoster have some methods of unpacking huge ..

Transfering a Database driven website - Hello Folks, I have been asked to upload a website to a new ISP, the website was sent to me in zipped format. When I unzipped it, I found it to be php files and images. Some of the php pages are accessing a MySQL database. Really I need an outline....

CONTRACT EMPLYER SEEKS EXPERIENCED PHP/MY SQL/DATABASE/ IN.. - HELLO PLEASE-DOPER'S., LAMERS, LAZY FOLKS AND BS ARTISTS NEED NOT RESPOND I SEEK HELP WITH THE BACK DOOR STUFF- THETH MY SQL INTEGRATION AND THE SETTING UP OF DATABASES/ INTEGRATION OF PHP SCRIPTS WITH MY SQL I WROTE MY WEBSITE WITH MACROMEDIA USING..

PHPtriad v2.2.1 removal - When I fist started using apache/php/mysql I used phptriad [a wonderful piece of kit] to get me up and running. I've used this ever since. I'm think inow of 'upgrading' to laters versions of all three applications, and have found various tutorials/Ho...
   Database Help (Home) -> PHP SQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]