I have a web form that writes data to a Microsoft SQL server. I believe that my data should be utf8 because there are some special symbols that I need.
I want to insert this into a nvarchar field:
• NMMA Yacht/CE Certification • Transferable 5-Year Formula Guard® Limited Protection Plan w/10-year Structural Warranty (USA only)• Ashland Maxguard™ LE gelcoat in White or Soft White• Imron® standard graphic in A, B or C • Pressure-treated Perma Panel™ structural hull matrix w/foam-filled hull cavities • Chemically bonded & thru-bolted deck-to-hull joint • Heavy-duty PVC gunwale w/stainless insert • Concealed fiberglass anchor locker• 316L bow rail• Stainless hardware & 316L welded rails• Stainless Formula logo-cast cleats (6), fuel fill, polished engine vent trim & port lights w/screens (2) • Continuous tinted, tempered curved-glass windshield w/stainless top frame, center walk-thru & windshield wiper• Electric horn • 316L stainless transom grab rail & tow eye• Clarion® waterproof transom-mounted stereo control • Integrated swim platform w/concealed stainless swim ladder • Transom shower
but what get inserted into the database is:
â€¢Â NMMAÂ Yacht/CEÂ CertificationÂ â€¢Â TransferableÂ 5ÂYearÂ FormulaÂ GuardÂ®Â LimitedÂ ProtectionÂ Plan w/10ÂyearÂ StructuralÂ WarrantyÂ (USAÂ only)â€¢Â AshlandÂ Maxguardâ„¢Â LEÂ gelcoatâ€¢Â StandardÂ graphicÂ in A,Â BÂ orÂ CÂ w/Axaltaâ„¢Â ChromaÂ PremierÂ®Â basecoatÂ &Â ImronÂ®Â EliteÂ clearcoatâ€¢Â PressureÂtreated PermaÂ Panelâ„¢Â structuralÂ hullÂ matrixÂ w/foamÂfilledÂ hullÂ cavitiesÂ â€¢Â ChemicallyÂ bondedÂ &Â thruÂbolted deckÂtoÂhullÂ jointÂ â€¢Â HeavyÂdutyÂ PVCÂ gunwaleÂ w/stainlessÂ insertÂ â€¢Â ConcealedÂ fiberglassÂ anchor lockerâ€¢Â StainlessÂ hardwareÂ &Â 316LÂ weldedÂ railsâ€¢Â StainlessÂ FormulaÂ logoÂcastÂ cleatsÂ (8),Â fuelÂ fill, polishedÂ engineÂ ventÂ trimÂ &Â polishedÂ portÂ lightsÂ w/screensÂ (2)Â â€¢Â ContinuousÂ tinted,Â tempered curvedÂglassÂ windshieldÂ w/stainlessÂ topÂ frame,Â centerÂ walkÂthruÂ &Â windshieldÂ wiperâ€¢Â Concealed airÂ hornÂ â€¢Â 316LÂ stainlessÂ transomÂ grabÂ railÂ &Â skiÂ towÂ eyeâ€¢Â ClarionÂ®Â waterproofÂ transomÂmounted stereoÂ controlÂ &Â twoÂ 6Â1/2"Â speakersÂ w/polishedÂ stainlessÂ grillesÂ Â â€¢Â IntegratedÂ swimÂ platform w/concealedÂ stainlessÂ swimÂ ladderÂ &Â pullÂupÂ cleatsÂ (WoodgrainÂ vinylÂ deckingÂ w/outboard configuration)â€¢Â TransomÂ showerâ€¢Â ChromeÂfinishedÂ cityÂ waterÂ inlet
I think maybe it has something to do with collation. But not quite sure how to set it properly. I believe all my form stuff is configured for UTF8.
Any ideas how to configure the database?