Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Collation for default
Message
 
 
To
14/01/2013 11:18:07
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01562454
Message ID:
01562458
Views:
32
>hi,
>
>CREATE TABLE #parametros (parameters varchar(500))
>
>collation which is taking the field(parameters) in a Windows 2003 server in English, Latin or Spanish
>
>I do this in a stored procedure

Add

CREATE TABLE #Parameters (Parameters VARCHAR(500) COLLATE DATABASE_Default)

By default if you don't specify collation, it will get it from TempDb database which may be different than the database you're working with. If you want to use the same collation, add COLLATE DATABASE_DEFAULT to all character columns. This is a known problem often discussed in MSDN Transact-SQL forum.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform