Hi, my problem is i have to put the french text like this one : Le revenu d'exploitation par action selon la comptabilit� de caisse1, du deuxi�me trimestre s�est �tabli � 0,84 $ contre 0,84 $ pour la m�me p�riode de l�exercice pr�c�dent into my database table. I am developing a site in which the admin section allows both english and french entries. The English version works perfect but when i try to put a french text into the oracle table, the CFQuery sent the text to the oracle table but somehow some of the french characters stored in the table column is changed. It looks like oracle has changed some of the french characters when it is stored in the column. So when CFQuery select retrieves the french text stored in the table and displayed on the web page, the text is different from the original one. I am trying to use SQL Plus to insert a french text but an error "ORA-01756: quoted string not properly terminated" returns. I believe it is because of the existing single quotes in the french text which screw up the SQL insert statement. Anyone has any idea to deal with this kind of problems ? On Fri, 18 May 2001 12:19:20 +0100 Stephen Galligan wrote: >Oops forgot to say the rest! > >SELECT TO_CHAR(sale_date, 'Day DD Month YYYY HH24:MI:SS') as nice_sale_date >FROM sales >WHERE sales_id=3939 > >This would return >Nice_sale_date >------------------ >Wednesday 25 October 2000 00:16:13 > >if you do the same query and add the NLS specifier >SELECT TO_CHAR(sale_date,'Day DD Month YYYY >HH24:MI:SS','NLS_DATE_LANGUAGE=FRENCH') as nice_sale_date >FROM sales >WHERE sales_id=3939 > >you get it in fran�ais > >Nice_sale_date >------------------ >Mercredi 25 Octobre 2000 00:16:13 > >Hth >s > > > >-----Original Message----- >From: FARRAH NG [mailto:[EMAIL PROTECTED]] >Sent: 17 May 2001 20:03 >To: CF-Talk >Subject: defining french table in oracle > > >Hi everybody, >Does anyone has the experience of creating a oracle database to store >french characters ? Please give me advise of how to do this, if >anyone has this experience before. > >thanks > > > > >-------------------------------------------------------------------------- >Global Internet phone calls, voicemail, fax, e-mail and instant messaging. >Sign-up today at http://www.hotvoice.com > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
