 |  |  |  |  |  |  |  |
Where is AlwaysUseDefaultCodePage?
Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I'm using SQL Server 2008, the SQL Server Management Studio. I'm trying to import from a flat text file into my mssql database, but it inevitably fails, resulting in the error:
The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it
I googled and whatnot, and saw the suggestion to set AlwaysUseDefaultCodePage to true, but I can't find that setting anywhere! Is there a way to do this from with the management studio or set via query or something?
The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it
I googled and whatnot, and saw the suggestion to set AlwaysUseDefaultCodePage to true, but I can't find that setting anywhere! Is there a way to do this from with the management studio or set via query or something?
•
•
Join Date: Aug 2006
Posts: 2,065
Reputation: 
Solved Threads: 256
Give me sample row in the text file and table structure (columns and datatypes)
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
|
Other Threads in the MS SQL Forum
- Previous Thread: Allowing NULL search in SelectCommand of SQLDataSource
- Next Thread: make sth. like pivot with mssql 2000
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads