Red Gate forums :: View topic - bug report: '' are wrong
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

bug report: '' are wrong

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Petro



Joined: 15 Nov 2005
Posts: 10

PostPosted: Fri Mar 14, 2008 6:09 pm    Post subject: bug report: '' are wrong Reply with quote

hi all

first of all, this tool is really good Very Happy .... but i have a big problem with SQL Multiscript. It can not handle '' (a with two dots) Evil or Very Mad

Can i make a speciall setting? If not, when will this bug be fixed. Because till this problem is fixed, it is risky for us to use SQL Multiscript! Confused

We already have 5 Licences Crying or Very sad

Thanks for answer
petro
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Mon Mar 17, 2008 9:07 am    Post subject: Reply with quote

Hi Petro,

There are some known issues with SQL Multiscript and script text encoding.

In what way are you not seeing Multi Script handle those characters?

Daniel
Back to top
View user's profile Send private message
Petro



Joined: 15 Nov 2005
Posts: 10

PostPosted: Mon Mar 17, 2008 11:51 am    Post subject: Reply with quote

Hi Daniel

in a script we have a insert like ....
insert into XXX( TEXT_STR )
select 'Einfache Auswertungen bernehmen'

after SQL-Mulitscript read it, it's changed to....
insert into XXX( TEXT_STR )
select 'Einfache Auswertungen �bernehmen'

if we can't handle this, it will be a big problem for us.

thanks for answer
petro
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Mon Mar 17, 2008 12:09 pm    Post subject: Reply with quote

Hi Petro,

Sql Multi Script loads all text files as if they were UTF8 encoded. Unfortunately this causing the problem you are seeing. We are hoping to address this in a future release of SQL Multi Script.

You can work around this issue by saving your scripts as a UTF8 encoded text file rather than an ANSI encoded file.

Regards,

Daniel
Back to top
View user's profile Send private message
Petro



Joined: 15 Nov 2005
Posts: 10

PostPosted: Wed Mar 19, 2008 5:55 pm    Post subject: Reply with quote

Hi Daniel

Thanks for your answer. We did not decide if we go the workaround, because this is a quite big change for us.

We hope the new release can read ansi and we hope it comes soon.

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