How to solve the database in Thephile due to the problem of sort: code page conversion is not supported for the text data type. From: 1252 to: 936 ---------------------------------------------------------------------------------------------------------------------------------- ---------------- Problem: Recently I am watching "ASP.NET Web Site Advanced Programming Problem - Design Solutions - Solutions" Forum, when debugging Topic.aspx page The following error occurred: The error occurred in: http://localhost/thephilevb/webmodules/rums/topic.aspx? TopiciD = 50
Error Message: Code page conversion is not supported on the text data type. From: 1252 to: 936.
ERROR Stack: System.data.sqlclient.sqlexception: Code page conversion is not supported for the text data type. From: 1252 to: 936. at System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader (CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill (Object Data, Int32 StartRecord, INT32 MaxRecords, String Srctable, IDBCommand Command, Commandbehavior Behavior) ... () ------------------------ ------------------------------------- This problem is due to the design time, the original database is used. : English (US) 0x409 Latin1_General 1252
Due to the operating system, we need Simplified Chinese (People's Republic of China) 0x804 Chinese_PRC 936,
1. Generate two different databases, thephile, thephiletemp, restore data from the backup file; generate the IPL script; delete all user tables in Thephile. 2. Change collate sql_latin1_general_cp1_ci_as in the script to collate chinese_prc_ci_as 3. Use SQL scripts to regenerate the table in Thephile; use the tool in SQL Server, export data from thephiletemp, import it to the Phile OK
