DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   MS SQL (http://www.daniweb.com/forums/forum127.html)
-   -   Where is AlwaysUseDefaultCodePage? (http://www.daniweb.com/forums/thread168138.html)

jjfletch Jan 13th, 2009 1:27 pm
Where is AlwaysUseDefaultCodePage?
 
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?

Ramy Mahrous Jan 13th, 2009 3:38 pm
Re: Where is AlwaysUseDefaultCodePage?
 
Give me sample row in the text file and table structure (columns and datatypes)


All times are GMT -4. The time now is 5:17 am.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC