PC Review


Reply
Thread Tools Rate Thread

Collating Order 1024 vs 1033

 
 
Christine
Guest
Posts: n/a
 
      26th May 2004
I am working on a method for updating table schema on customer
databases out in the field. I notice that when I add a field using DAO
code, it has a CollatingOrder of 1024. But when I add a field using
the interactive Design View technique, it has a CollatingOrder of
1033. The CollatingOrder does not seem to be editable. I am using
Access 2000.

1. What does CollatingOrder 1024 mean? 1033 is dbSortGeneral. 1033 =
1024 + 9, so perhaps there are those 2 extra bits set to go from 1024
to 1033 that have some meaning.
2. Is there anything I can do to have my code added fields have the
1033 CollatingOrder? In my experimenting, I do not do anything that
would change the DB collatingorder between trying out a code field add
and the Design View field add.
3. Does it really matter at all? In other words, is 1024 'as good' as
1033. My customers are all U.S. based - no foreign languages involved.

Many thanks to all of you out there who help out most generously with
your experience and words of wisdom.

Christine
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the collating (sort order) of files in WinXP =?Utf-8?B?Smlt?= Windows XP Help 1 9th Dec 2006 05:55 AM
Error 1033 =?Utf-8?B?U2hhbnph?= Microsoft Excel Crashes 0 23rd Nov 2005 06:58 PM
News take me to 1033 Pat Gardiner Microsoft Outlook 2 10th Jul 2005 06:14 PM
MSMAPI 1033 Error Ann Meyer Microsoft Outlook Contacts 2 5th Dec 2003 01:09 AM
error 1033 babby Windows XP Basics 0 1st Aug 2003 08:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:46 PM.