Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 26th, 2006, 01:57 PM
Registered User
 
Join Date: May 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Thai Font Change in ???????

I would like someone to help me. I use ASP, MS SQL 2000 and Window2000 Server. I have 3 fields for record data, NameTH, NameEN, NameJP. First time, I use only 1 textbox insert in 3 fields. Thai font has no change. Second time I recall data from database(use Sql language "Select * from....................."). During Update, Thai font change in ???????. But other fields are not chage in ????????. I hope someone solve this problem to me.

                                     Thanks.
                                      Montri

 
Old June 12th, 2006, 10:35 PM
Authorized User
 
Join Date: Sep 2003
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to prabodh_mishra
Default

Hi Montri,

I've never confronted such problem nor your Thai language but I beleive that there are certain language here on this earth that uses DBCC i.e. that occupies 2 bytes to store there one character like few Chinese and Japanese Kanjhi.

In such cases one must use National Character Set that is nVarchar or nText in place of varchar and text data types.

I hope it may help you.

Cheers,
Prabodh


Thought of the era:
If you cry b'coz the sun has gone out of your life, your tears will prevent you from seeing the stars.






Similar Threads
Thread Thread Starter Forum Replies Last Post
MessageBox Font change vgsgowrisankar C# 2005 5 April 8th, 2008 04:10 AM
How to change font using winspool FileFound Visual Studio 2005 0 July 9th, 2007 04:57 AM
change font color of label red pritz BOOK: Professional JavaScript for Web Developers ISBN: 978-0-7645-7908-0 0 November 14th, 2005 03:48 AM
prevent font size change in Firefox nerssi Javascript 3 July 30th, 2005 10:10 AM
change font is template column Raif General .NET 0 July 28th, 2004 02:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.