mysql upload scripts october 2013

[gianluca.tarasconi]

dear all

from my blog at this link:

http://rawpatentdata.blogspot.it/2013/1 ... pload.html

is possible to download scripts for mysql that allow to upload last version of patstat

[nico.rasters]

You have to add ESCAPED BY '' because the EPO doesn't escape the backslash.
That is the reason behind the 25 delta imp for TLS202_APPLN_TITLE. Some lines end with \", MySQL quietly assumes that the backslash is escaping the double quotes and therefore the quote is ignored as an escaping character and the following line is included in the same record.

I think the PATSTAT documentation mentioned somewhere that all double quotes within texts are replaced by spaces. I think it would have been better to escape them... or to use a tab as a delimiter because then you wouldn't need double quotes as enclosing characters in the first place.

Anyway, if you add ESCAPED BY '' it will work... though I have a feeling the backslash is some sort of typo (it's right next to the Enter button).

[gianluca.tarasconi]

I'll try

thanks Nico