unicode problems with mx7

Forum|Forum|17 years ago
April 8, 2008
5 replies
679 views

hello all

setup: coldfusion mx 7.0.2, sql server 2000 db

i have a weird problem:
- the page is multilanguage and everything is programmed in utf-8 as charset. database fields are nvarchar.
- problem language is czech with some special characters:
- if i enter the text directly into the database using ms access adp, the data is stored correctly in the database and displayed correctly in coldfusion with cfoutput.
- but if i have a form and SAVE data into the database. SOME chars are altered and the data is not saved correctly into the database. see a jpg of this here
- a quick testprogram worked fine : small form, post the text to itself and output the formfield.

so, the problem seems to be the java database-connector (native cf version used). what am i missing or which settings are messed up?

thanks for some help... :)

cheerios from switzerland, lukas

Database access

This topic has been closed for replies.

M

munmun77

Participating Frequently

Can you pls advice the method to use for Oracle server.

Thank you.

N

Newsgroup_User

Inspiring

munmun77 wrote:
> I actually try to use the code found at :
> http://www.sustainablegis.com/unicode/greekTest.cfm
>
> But it does not seems to work.

no, it wouldn't. that's for sql server.

M

munmun77

Participating Frequently

Hi,

I have the same problem. But I am using CF 8, Oracle 9i.

I actually try to enter my Traditional Chinese char in the following site, it works.
http://www.sustainablegis.com/unicode/greekTest.cfm

But when I use in my server, it does not seems to work.
Pls help.

Thank you.
Serene

N

Newsgroup_User

Inspiring

woddel wrote:
> hello all
>
> setup: coldfusion mx 7.0.2, sql server 2000 db

see this:

http://www.sustainablegis.com/unicode/greekTest.cfm

N

Newsgroup_User

Inspiring

see if this helps:
http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18331&sliceId=2

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/