切換為 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%AA%BF%E7%94%A8%E8%B3%87%E6%96%99%E5%BA%AB%E7%9A%84%E4%BC%BA%E6%9C%8D%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%E8%B3%87%E6%96%99%E5%BA%AB%E5%8F%83%E8%80%83%EF%BC%9A%20%20%20%60%60%60%20%20%20%3CdataSource%20name?lang=zh-Hant="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