Red Gate forums :: View topic - Data formatting problems
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Data formatting problems

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dhanjel



Joined: 25 Jan 2010
Posts: 3

PostPosted: Mon Jan 25, 2010 11:18 am    Post subject: Data formatting problems Reply with quote

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?
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Wed Jan 27, 2010 4:16 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
dhanjel



Joined: 25 Jan 2010
Posts: 3

PostPosted: Mon Mar 22, 2010 12:48 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Mar 22, 2010 12:56 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
dhanjel



Joined: 25 Jan 2010
Posts: 3

PostPosted: Mon Mar 22, 2010 1:50 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon May 10, 2010 6:16 pm    Post subject: Reply with quote

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/viewtopic.php?p=35709
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group