Messages

1

ThumbsPlus v10 Questions / Adding Unicode support to existing SQL Server Database

« on: 2016-03-06 04:44:30 »

I looked at the most recent database creation script. It looks like all old varchar columns should now be nvarchar. This explains (obviously) the issue I described with find in my previous post.

My problem is that from what I have seen an existing column cannot just be converted without dropping the table and recreating it (which is not a good thing if it is already populated with data).

I had to do it by creating a new column, copying over from the old column, renaiming old to new, deleting the old one and dealing with eventual indexes.

Does anybody have a script to do this??? Maybe Cerious has a script to convert an older database???

2

ThumbsPlus v10 Questions / Adding Unicode support to existing SQL Server Database

« on: 2016-03-05 13:13:07 »

Ok, I just did it (no risk no fun, right?).

So far everything seems to be working. I had to go with nvarchar(255) as max would have not allowed to index the field. Nor really an expert so I first thought there was no 255 option as it was not in the drop down list ...haha.

Still interested in hearing from you if here are any caveats I should be aware of.

And if anybody has the same issue just drop me a reply and I will happily post a more detailed description of how I proceeded (without warranty and to be followed at your own risk!!!)

ne small thing I noticed is that the search (Find - Fle name mask) won't work with special characters. However if you cancel it and start it again it substitutes all special characters with ? and then it does find the files. Might be on purpose as if you have varchar in your database instead of varchar that's what TP gets out of the database for the name.

Still have to figure out how to get rid of the orphans that I have in the database from before (other than scanning for orpans, but htat would eliminate all orphans and I have some that are there on purpose and I want to keep).

3

ThumbsPlus v10 Questions / Adding Unicode support to existing SQL Server Database

« on: 2016-03-05 09:02:46 »

Hi,

having been a user of TP for a while I had switched to MS SQL Server database years ago. I understand that Unicode support would now be possible for filenames. The fact that for me it doesn't work might depend on the fact that the coresponding columd for the name in the database seems to be defined as varchar(255). Could I just redefine this to nvarchar(MAX) in the existing database (without bricking it) to fix the problem or is there another more advisable instruction, script or other?

Thank you all in advance for your help with this.

Gregor

4

ThumbsPlus v10 Questions / Ghostscript

« on: 2016-02-28 05:06:38 »

P.S.: this also applies to other 'special' characters like ° accented vocals (like ó á à è é ö ü ä etc.) alternative versions of ' and - (the primary characters work).

5

ThumbsPlus v10 Questions / Ghostscript

« on: 2016-02-28 04:26:16 »

Thanks, I installed the latest release but that was not it. I found out that Ghostscript seems not to be the problem. Ghostscript EXE works fine and Ghostscript DLL called via the new Gsview V6 also works. Interestingly when the DLL is being called by the old Ghostgum V5 of Gsview shows what the problem seems to be: the part (directory name or file name) with the § character gets substituted by 247\ and thus the file cannot be found. Probably the TP plugin calls the Ghstscript DLL the same way the old Gsview was doing it and runs into the same problem.

Maybe Cerious can make something of my attempt at an explanation and will be able to fix this.

Best

Gregor

6

ThumbsPlus v10 Questions / Ghostscript

« on: 2016-02-27 04:01:29 »

Hi,

I was having intermittent trouble with PDF thumbnailing and display for a while. I now found out that if anywhere in the filename or path there is a § character that's what is causing the problem. I think it might be a problem of Ghostscript itself as I now verified that it happens also when TP is not involved.

Can somebody tell me whether it is known generic problem or it happens only to me (with my config)?

Or does anybody know about a workaround (other then renaming the file)?

I am using gs9.16 (32 or 64 bit) the latest stable TP10 and Windows 7.

Thank you all in advance

Gregor