MySQL Forums
Forum List  »  Portuguese

Update com caracteres especiais
Posted by: RONALDO SOUZA
Date: August 12, 2020 03:01PM

Boa tarde,

Estou tentando efetuar um UPDATE na tabela do MYSQL via ODBC, o update seria o seguinte:


UPDATE OPENQUERY(WOOCOMMERCE, 'select ID, post_title, post_name, post_content, post_excerpt, post_modified, post_modified_gmt, sku from wp_ixd5jn_posts where post_type = ''product'' and post_status = ''publish'' and sku is NOT null')
set post_title = @POST_TITLE COLLATE Latin1_General_CI_AS
WHERE sku = @codprod

O post_title está declarado da seguinte forma:
@POST_TITLE NVARCHAR(MAX),

Esse campo tem vários caracteres especiais, quando não há esses caracteres o Update funciona, preciso mudar esse COLLATE ou algo assim?

Grato.

Options: ReplyQuote


Subject
Views
Written By
Posted
Update com caracteres especiais
172
August 12, 2020 03:01PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.