what datatype is used for the text fields in the database? If it's
nvarchar, they are stored as unicode character data, UCS-2 encoded. You
probably need to use unicode UTF-8 or ISO-Latin-1 encoding for your text
data for the browser to understand it (you'll run into problems trying to
use UCS-2 on any unix platform anyhow). In addition, ColdFusion doesn't
support the Unicode character set, only sub-sets of it depending on your
locale settings and Oracle has similar restrictions so you'll probably just
wanna stick with ISO-Latin-1.
I've never actually used nvarchar in SQL server, but I'd guess you can
simply change the datatype to varchar and existing data will be translated
to ISO-Latin-1 (actually, it might be stored as ANSI, I'm not sure off the
top of my head).
Mark
At 08:45 AM 8/15/2001, you wrote:
>Hi there,
>
>I'm using the MsSQL driver to connect to an MsSQL 7 database
>on an other
>server.. That works oke... But i have a real strange thing..
>
>When i have fields in the result of a query that contains
>specials characters
>like A-umlaut, A-tilde it gives me the 'unknown' character
>(the blocky thing).
>
>Is there a way to solve this (on Linux level) or is it a
>problem of the MsSQL driver ?
>
>Grtz,
>Stefan
>
>-------------------------
>Stefan Verstege
>KPN OVN BBT/IP
>OSU ISS
>Tel: 070 - 4512692
>Mob: 06 - 54910175
>
>
>
>
>***************************DISCLAIMER***********************************
>Deze e-mail is uitsluitend bestemd voor de geadresseerde(n).
>Verstrekking aan en gebruik door anderen is niet toegestaan.
>KPN N.V. sluit iedere aansprakelijkheid uit die voortvloeit uit
>elektronische verzending.
>
>This e-mail is intended exclusively for the addressee(s), and may
>not be passed on to, or made available for use by any person
>other than the addressee(s).
>KPN N.V. rules out any and every liability resulting from any
>electronic transmission.
>************************************************************************
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
