bug report: 'äöü' are wrong

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

bug report: 'äöü' are wrong

Postby Petro » Fri Mar 14, 2008 6:09 pm

hi all

first of all, this tool is really good :D .... but i have a big problem with SQL Multiscript. It can not handle 'äöü' (a with two dots) :evil:

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! :?

We already have 5 Licences :cry:

Thanks for answer
petro
Petro
 
Posts: 10
Joined: Tue Nov 15, 2005 9:48 am

Postby dlkj » Mon Mar 17, 2008 9:07 am

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
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge

Postby Petro » Mon Mar 17, 2008 11:51 am

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
Petro
 
Posts: 10
Joined: Tue Nov 15, 2005 9:48 am

Postby dlkj » Mon Mar 17, 2008 12:09 pm

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
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge

Postby Petro » Wed Mar 19, 2008 5:55 pm

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
Petro
 
Posts: 10
Joined: Tue Nov 15, 2005 9:48 am


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests