Print Page | Close Window

Problem with message display in foreign language

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29162
Printed Date: 01 April 2026 at 2:25pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Problem with message display in foreign language
Posted By: noyshani
Subject: Problem with message display in foreign language
Date Posted: 03 March 2011 at 12:38pm

Hello,

I need some advice.

My discussion board users are writing mostly in Hebrew.
I have recently moved my website to a web server in England but experiencing lots of language compatibility problems.
I had to manually scrip all the web wiz forum database tables onto my new SQL Server 2008 database because the import wizard broke the table structure by making some seeded columns regular columns. This was complicated enough. Halfway through the process I have noticed that in the Thread table 'Message' is stored as 'text'. As I do not have much access to my current database settings it is actually defined with a latin locale while my previous one was defined with a hebrew locale.
To be able to transfer all data properly I had to change the locale of the Message column to Hebrew (i do not have permissions to change the whole database locale). This way I was able to transfer all the hebrew data properly.


The problem is that each message's text appears on the forum_posts page with question marks instead the hebrew text. but this is the only value to appear like that! (I might have a similar issue with the PM_Message text as well). Everything else including user names, topic subjects, etc appear properly in Hebrew. I am using the right meta tag with windows-1255 and a code page equal to 1255 across the whole system.
Why is this happening and how can I sort that? I am in real need for help.

Thank you in advance.

Kind regards,
Noy.

 
P.S: I did try to search this forum before I posted this, but this is so specific and I could not find anything that could help me.



Replies:
Posted By: noyshani
Date Posted: 03 March 2011 at 12:52pm

I will note the values in the database are indeed stored in proper Hebrew as even though the column is of data type 'text' I defined the column to have a hebrew collation. The problem is only to do with how Thread.Message is displayed on the relevant page(s)



Posted By: 123Simples
Date Posted: 03 March 2011 at 4:35pm
A technical person (someone brighter than me) may be able to answer your question shortly

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design


Posted By: WebWiz-Bruce
Date Posted: 04 March 2011 at 5:37pm
It sounds like you are using the Import/Export Tools in SQL Server Management Studio. These are totally useless as they drop much of the database schema.

What you need to do is create a backup of the database at your present provider (they should be able to supply you a .bak back of the database. You can then use this database backup to restore the database to your new host.

Using this method it will retain the schema and keep your data intact including any locale settings.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: noyshani
Date Posted: 04 March 2011 at 11:37pm

Hi Bruce,

 

Yes you are right. The import/export wizard is really no use. I have managed to solve this. Since my hosting company did not help me at all and I do not have permissions to restore my database I had to go through a very complex operation to solve this. What I had to is to script all tables and their primary and foreign keys. I had to do this in certain order. Then I built a SSIS solution with data flow tasks that pass the data. In the case of the PMMessage and Thread table I had to also do the following:

 

1) I created a new column with data type 'ntext' instead of the Message column which was of type 'text'. I had to delete the other column, rename the new one to the old one and then remove the keys, truncate the table and and the keys again.

 

2) I set this column's locale to Hebre locale.

 

3) In my SSIS package I created a data flow task that contains OLE DB source, data conversion transformation and OLE DB Destination -

 

* The data conversion converts the old 'text' column to format 'ntext'

* Both the OLE DB source and destination are defined with default code page of 1255 (represents Hebrew) in their properties. The OLE DB source is also defined to have the AlwaysUseDefaultCode as True.

 

Many other combinations I have tried caused the database to have either corrupted text, or actually even worse to have all the values in the database in proper Hebrew while on the website they did not appear correctly.

 

If I had permissions to restore my own database or if my hosting company would have agreed to do this for me all that work of literally days would be redundant...

Thank you for your reply,
Noy.



Posted By: WebWiz-Bruce
Date Posted: 05 March 2011 at 8:31am
If you are ever in this situation in the future then we do offer a Web Wiz Forums hosting service on our own servers and can migrate the forum and it's database for you to our servers as part of the Web Wiz Forums Migration Service for £19.95.

http://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - http://www.webwiz.net/web-wiz-forums/forum-hosting.htm

We can also include this service as part of our full website hosting as we also do full website hosting and host 1,000's of websites and forums on our own network.

We also supply online tools for uploading/restoring and creating/downloading backups of SQL Server databases.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: noyshani
Date Posted: 06 March 2011 at 12:03pm
Hi Bruce, thank you very much. I'll be considering it in the future.
 
Noy.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net