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