Click here to Skip to main content
15,906,329 members
Home / Discussions / Database
   

Database

 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 4:10
DonBush7-Nov-03 4:10 
GeneralRe: Creating a DBASE file Pin
Arjan Einbu10-Nov-03 11:07
Arjan Einbu10-Nov-03 11:07 
GeneralRe: Creating a DBASE file Pin
DonBush11-Nov-03 2:47
DonBush11-Nov-03 2:47 
QuestionMust be a permissions thing, but what? Pin
Colin Angus Mackay6-Nov-03 4:04
Colin Angus Mackay6-Nov-03 4:04 
Answer(Actually it wasn't) Pin
Colin Angus Mackay6-Nov-03 5:33
Colin Angus Mackay6-Nov-03 5:33 
GeneralRe: (Actually it wasn't) Pin
Michael Dunn6-Nov-03 13:01
sitebuilderMichael Dunn6-Nov-03 13:01 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson6-Nov-03 13:58
Jörgen Sigvardsson6-Nov-03 13:58 
GeneralRe: (Actually it wasn't) Pin
Colin Angus Mackay7-Nov-03 1:37
Colin Angus Mackay7-Nov-03 1:37 
I totally agree - The RDMS should not be handling presentation layer issues like date formats.

However some localisation issues may still be important - For example, collation order - It is much more efficient if SQL Server handles localised collation sequences. For example, take the values:

Lladró
London

is correct if you are dealing with the English language. But if you select Traditional Spanish as the locale in SQL Server 2000 you get the order:

London
Lladró

because in Traditional Spanish "LL" is considered a letter in its own right that is placed after "L" in the alphabet.

And if the database is localised to non-latin character sets how would the ORDER BY work without locale specific collation rules.

--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)


GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson7-Nov-03 3:11
Jörgen Sigvardsson7-Nov-03 3:11 
AnswerRe: Must be a permissions thing, but what? Pin
Giles7-Nov-03 3:49
Giles7-Nov-03 3:49 
GeneralRe: Must be a permissions thing, but what? Pin
Colin Angus Mackay7-Nov-03 5:10
Colin Angus Mackay7-Nov-03 5:10 
Generaldate Pin
Anonymous6-Nov-03 2:26
Anonymous6-Nov-03 2:26 
GeneralRe: date Pin
Colin Angus Mackay6-Nov-03 3:59
Colin Angus Mackay6-Nov-03 3:59 
GeneralRe: date Pin
Anonymous6-Nov-03 4:36
Anonymous6-Nov-03 4:36 
GeneralRe: date Pin
Colin Angus Mackay6-Nov-03 4:49
Colin Angus Mackay6-Nov-03 4:49 
GeneralSQL Statement question. Pin
theJazzyBrain6-Nov-03 1:25
theJazzyBrain6-Nov-03 1:25 
GeneralRe: SQL Statement question. Pin
Roger Wright6-Nov-03 3:24
professionalRoger Wright6-Nov-03 3:24 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 5:53
theJazzyBrain6-Nov-03 5:53 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi6-Nov-03 6:57
professionalJeff Varszegi6-Nov-03 6:57 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 7:36
theJazzyBrain6-Nov-03 7:36 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi6-Nov-03 7:39
professionalJeff Varszegi6-Nov-03 7:39 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 21:48
theJazzyBrain6-Nov-03 21:48 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi7-Nov-03 2:43
professionalJeff Varszegi7-Nov-03 2:43 
GeneralRe: SQL Statement question. Pin
theJazzyBrain7-Nov-03 4:04
theJazzyBrain7-Nov-03 4:04 
Generaluser acces spermissions Pin
ranjjj6-Nov-03 0:10
ranjjj6-Nov-03 0:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.