Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>>>>Hello Doug. I have no SET COLLATE statements anywhere in my application. When my application tries to open certain files this error pops up. All indexes in my files are set to machine collate. I do not make any explicit SET COLLATE statements.
>>>>
>>>>Is it possible that database collation is set to this file? E.g. what CPDBF() returns?
>>>
>>>No this is not possible. But I do use CREATE CURSOR and CREATE TABLE commands. Could this default to PINYIN collate sequence and then the file is missing?
>>
>>I actually meant tables in my reply, not DBC. Anyway, I believe it's possible for tables to have wrong collation if you didn't explicitly specify it.
>
>Yes, I am also talking about tables. They are all set to machine collate sequence. I really have no clue what collate sequence means or how to use. Have never needed to use it until this user in Singapore came up with this issue....
What does CPDBF() return for the tables? What does CPCURRENT() return? (note: it goes without saying, doing this on your computer is meaningless -- you get the values as returned on your customer's computer).
The last time I had similar error message, it turned out some tables had a different codepage set.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement