Data formatting problems

dhanjel

In the database we have the data type DateTime on a field and it is presented in the database as 2010-01-25 10:12:11.234

Some combinations of collations and/or locale settings on computers requires that there are no lines in the date-strings.

Is it possible to remove the lines between YYYY-MM-DD in the script generated from sql packager?

Linda Hawksworth

I have logged your request for SQL Packager to remove the dashes from the date format in the generated script (SPA-538). It will be considered for a future release of SQL Packager although we have no timescales for this at present.

dhanjel

It's been a couple of months now with no more information on this,
is there any known workaround for this problem?
We've tried to alter the locale settings with no luck.

Linda Hawksworth

I spoke to one of the development team about this. He asked if the iso format works, ie ISO8601 yyyy-mm-ddThh:mi:ss.mmm

Alternatively, could you tell us what collations/locales don't work?

dhanjel

Our export date format looks like your example above (from a swedish 2008 db) with "yyyy-mm-dd" but a French SQL express 2008 (French_CI_AS) does not accept this format when running the EXE from SQL packager.
However, if we generate the scripts, and then change the dates manually to yyyymmdd it works (when running the scripts manually).
The problem is that we generate an exe file with your tool and we have no way to change the dateformat to yyymmdd.

Is there any known workaround ?

Best regards
Daniel

Chris Auckland

Just to let you know that we now have a patch avaliable that should resolve the above issue.

For more information and a download link, see

http://www.red-gate.com/messageboard/vi ... hp?p=35709