Non-patent-literature, encoding error?
Posted: Thu Apr 30, 2020 5:33 pm
Dear PATSTAT community,
I am using PATSTAT for the first time and I am working with the Non-patent-literature (table: tls214_npl_publication).
I find several non-patent-publications which show me strange characters, I think due to encoding errors.
I put here an example of a query that will return a problematic publication:
select *
from tls_214_npl_publn
where npl_publn_id=985931482
This will return a string that is not intelligibile.
Did someone have the same issue? Are you aware of a solution?
Thanks a lot,
Elisa
ps. I am using Azure Data Studio.
I am using PATSTAT for the first time and I am working with the Non-patent-literature (table: tls214_npl_publication).
I find several non-patent-publications which show me strange characters, I think due to encoding errors.
I put here an example of a query that will return a problematic publication:
select *
from tls_214_npl_publn
where npl_publn_id=985931482
This will return a string that is not intelligibile.
Did someone have the same issue? Are you aware of a solution?
Thanks a lot,
Elisa
ps. I am using Azure Data Studio.