Hi Sergey,
----------------
Hi Fabio,
I think it's
Latin1_General_CI_AS
------------------
Also I thought it, but he is not therefore!
VFP COLLATE GENERAL not exists on SQL Server.
Example:
VFP
SET COLLATE TO "GENERAL"
IF CHR(32)=CHR(9)
? '='
ELSE
? '#'
ENDIF
Result is =
On SQL_Server
IF CHAR(32) COLLATE Latin1_General_CI_AS =CHAR(9) COLLATE Latin1_General_CI_AS
SELECT '='
ELSE
SELECT '#'
Result is #
I have write a complete routine for compare VFP COLLATE with SQL COLLATE.
Only MACHINE match with Latin1_General_BIN.
I have confidence in the collate ones of SQL_Server.
In-fact on SQL_Server with COLLATE Latin1_General_CI_AS:
'0'<'¼'<'½'<'1'
on VFP with SET COLLATE TO "GENERAL":
'¼'<'½'<'0'<'1'
Then, VFP "GENERAL" what is it ?
Exists one international norm on the COLLATE?
If i use VFP like front-end, Crystal Report like reporting i can
give different ordered result. Other problem exist.
Fabio