Bismarck,
Have you managed to get any records into the database with international
chars.
Are they within the Ascii value range or are they Unicode characters. If
they are Unicode, you'll need to set up fileds of type nchar. I'm not sure
if CF supports Unicode.
Also, I know tha MsSql7 asks some question about the Character set and
sorting options when you install the server.
In the Sybase's equivalent of Query Manager, run a SQL query to insert some
values into the table
INSERT INTO cust_names ( name )
values (����)
If this works try it from CF.
Hope this helps.
Regards
Michael O'Reilly
TransAer
-----Original Message-----
From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 3:31 PM
To: Cf-Talk (E-mail)
Subject: OT - Database and International Characters
Hello there,
I need to add customers names that contain international characters into a
Sybase database (�,�, �, � things of that sort) I currently first search
the names table to see if the record that I'm trying to add is already
there...
Exp.: select cust_id from cust_names where name = #new_name#
new_name can contains names with or without the international character,
everything is fine for names without these characters, but I get a database
error on every name that contains one of them... my question is, has anybody
encountered this before, and how where they able to solve it, is there a
function in ColdFusion that I can use to allow for the comparison? I have to
allow for the names to contains these, so dropping them is the last
option...
Bismarck Perez
----------------------------------------------------------------------------
--
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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
