How do I store Arabic Text in Sql Server 7.0

[Guest_imported]

How do i stone Arabic text in sql server 7.0. I have large amount of text to be inserted and to be displaed on the browser and search to be performed. When I try to insert in
normal way square boxes are coming.

Anybody have the solution kindly help me.

 

[jballum]

Are you using the needed character set for Arabic characters?

In Online Books:

"Important It is critical that you select the correct character set when you install SQL Server. To change character sets after installing SQL Server, you must rebuild the databases and reload the data."

1256 Arabic

JB

 

[Cagliostro]

You can use UNICODE for stiring every character sets in the same table and/or database. John Fill