Because CF can't do unicode, you can't use nvarchar, ntext or nchar, you
must use varchar, char and text.
As far as alternate character sets go, you're out of my area of expertise.
Hopefully, someone else on the list is more knowledgable.
Michael J. Sheldon
Internet Applications Developer
Phone: 480.699.1084
http://www.desertraven.com/
PGP Key Available on Request
-----Original Message-----
From: CT, Loo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 11, 2000 02:27
To: [EMAIL PROTECTED]
Subject: Re: Chinese language
Thanks Mike,
1. however, I still have some questions
regarding developing dynamic web pages that interacts with SQL database.
I am having the data type for the field as nvarchar (60), say this is the
product name. How can I store and retrieve the data and to trim the string?
2. Do we really need to use unicode for multilingual support webpage? Can I
define the datatype to normal datatype such as varchar? I still can store
the data that create using chinese word processor and the information would
still store into the database, right?
Thanks in advance.
Kind regards,
Loo
-----Original Message-----
From: Mike Sheldon <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, July 11, 2000 1:49 PM
Subject: RE: Chinese language
>>>actually there are some non-english language site names, i know
>of a thai language "dns" service which i *think* operates like a
>bookmark service.<<
>
>The base domain name is still 7-bit ascii. There are a couple of services
>that perform some interesting, limited hacks in order to allow non-ascii
>characters, but that's what they are, hacks. The DNS system would have to
be
>massively overhauled (replaced) in order to support double-byte characters.
>I've written DNS protocol-level software, and the packet formats just don't
>have the flexibility. And, SMTP can't handle 8 bits, let alone 16. :)
>
>Michael J. Sheldon
>Internet Applications Developer
>Phone: 480.699.1084
>http://www.desertraven.com/
>PGP Key Available on Request
>
>-----Original Message-----
>From: Paul Hastings [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 10, 2000 22:25
>To: [EMAIL PROTECTED]
>Subject: Re: Chinese language
>
>
>> Cold Fusion does not support Unicode characters. I'm not sure if there's
a
>> Chinese language version of CF or not, Allaire's site is not fully
>> functional.
>
>no there isn't a chinese cf version. we'll most likely have to wait for
>cf5.0
>for full function unicode.
>
>> >>3. I was told there are chinese character domain name and email
>address,
>> is that true? if yes, how do we search for such email addresses and
domain
>> names?
>>
>> No, that is false. The SMTP and DNS only support 7-bit ASCII characters,
>and
>> even a few of those are off-limits.
>
>actually there are some non-english language site names, i know
>of a thai language "dns" service which i *think* operates like a
>bookmark service.
>
>---------------------------------------------------------------------------
-
>--
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
