切换到 Unicode

对于Linux/PostgreSQL中现有的​prod​实例,切换到unicode的步骤如下:

  1. 停止写入数据库的进程:

    su - neolane
    nlserver shutdown
    
  2. 转储数据库:

    su - postgres
    pg_dump mydatabase > mydatabase.sql
    
  3. 创建Unicode数据库:

    createdb -E UNICODE mydatabase_unicode
    
  4. 还原数据库:

    psql mydatabase_unicode < mydatabase.sql
    
  5. 更新指示数据库为Unicode的选项:

    psql mydatabase_unicode
    update XtkOption set sStringValue = 'u'||sStringValue where sName='XtkDatabaseId' and sStringValue not like 'u%';
    
  6. 在跟踪服务器上:

    su - neolane
    cd nl6/conf
    vi config-prod.xml
    

    将​u​字符添加到与数据库标识符(databaseId)相关的值前面:

    <web>
     <redirection databaseId="u7F0000010554364C" trackingPassword="myPassword="/%3E%20%20%20%3C/web%3E%20%20%20%60%60%601.%20%E5%9C%A8%E8%B0%83%E7%94%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%9C%8D%E5%8A%A1%E5%99%A8%E4%B8%8A%EF%BC%9A%20%20%20%60%60%60%20%20%20su%20-%20neolane%20%20%20cd%20nl6/conf%20%20%20vi%20config-prod.xml%20%20%20%60%60%60%20%20%20%E4%BF%AE%E6%94%B9%E6%95%B0%E6%8D%AE%E5%BA%93%E5%BC%95%E7%94%A8%EF%BC%9A%20%20%20%60%60%60%20%20%20%3CdataSource%20name?lang=zh-Hans="default">
     <dbcnx encrypted="1" 
     login="<dbuser>:<base_unicode>" password="xxxx="
     provider="postgresql" server="yyyy"/>
    </dataSource>
    
  7. 重新启动所有计算机:

    /etc/init.d/apache stop
    /etc/init.d/nlserver6 stop
    /etc/init.d/nlserver6 start
    /etc/init.d/apache start
    
  8. 确认交换机。 为此,请通过Adobe Campaign控制台连接,并:

    • 检查数据是否正确显示,尤其是突出显示的字符:
    • 启动投放并检查跟踪检索是否有效。

在此页面上

Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now