Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collation for default
Message
 
 
À
14/01/2013 11:18:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01562454
Message ID:
01562458
Vues:
31
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform