Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2000 Stores Arabic Text As ASCII Code!

Status
Not open for further replies.
Bikzit

Bikzit

Programmer
Mar 24, 2001
9
0
0
AE
Guys, I have a big problem
I'm inserting Arabic text in SQL Server 2000 database, but it seems that SQL Server 2000 stores the Arabic text as ASCII characters. I use WebEditPro, so i save text and HTML tags, not text only. The problem appears when I try to do a search inside that field of the type (nText), I got no result coz ColdFusion compares Arabic text to ASCII code. How can I solve that problem guys? If you ask why did i use nText, that's coz it holds a larage amount of text.
With regards. <CFBikzit Text=&quot;Hi There&quot;>
 
Status
Not open for further replies.

Similar threads

fdgsogc
  • Locked
  • Question
Displaying results of an SQL Pivot Query
Replies
1
Views
127
jdhilljr
jdhilljr
HansKok
  • Locked
  • Question
Error after only changing text and not codes
Replies
0
Views
106
HansKok
HansKok
ibeenjammin
  • Locked
  • Question
FrameMaker 2015 Conditional Text Problems
Replies
0
Views
105
ibeenjammin
ibeenjammin
LyndonOHRC
  • Locked
  • Question
CFpdf Tag Locking up my server 1
2
Replies
21
Views
301
jdhilljr
jdhilljr
LyndonOHRC
  • Locked
  • Question
Javascript code will not execute if a cfdocument tag is in my document
Replies
1
Views
74
LyndonOHRC
LyndonOHRC

Part and Inventory Search

Sponsor

Back
Top