Electrical – How to find a DB9-type connector color code

I think you'll find assembling it pretty straightforward when you have the bits in your hand. It's the 'now injection-mould the body' stage which comes next that you'll struggle with.

For a one off repair like this, you can probably do something useful with heatshrink to keep it all together.

Alternatively, cut an existing USB cable in half, and use the 'A' end with some of its attached cable. Then you'll only have to join the cables - another heatshrink job.

The original serial connectors were 25 pins, with some/many/most of the pins used. The DB-9 RS-232 connector just takes the nine most popular pins from the DB-25 connector. In either DB-25 or DB-9 connector, which pins are actually used depends on the hardware/software implementation of the serial protocol. At minimum, for two-way serial communication you need just three pins:

• RX (Receive) - connected to TX on the other end. Pin 2 on standard DB-9 and DB-25
• TX (Transmit) - connected to RX on the other end . Pin 3 on standard DB-9 and DB-25
• GND (Signal ground) - Pin 5 on standard DB-9 and pin 7 on standard DB-25

(Note that sometimes particular serial cables are wired in non-standard way, but this is very rare. Indeed, there is a number of possible serial connectors). If your serial communication is one-way then you might only use two pins: TX/RX and GND.

The particular cable you have connects the six most popular lines. Cables that connect only some of the DB-9 serial lines are widely available, though do not assume that the same six pins are connected on all DB-9 cables. Depending on your needs, the six connected pins may or may not be sufficient. If you know which pins your hardware/software needs, then you would look for a cable that has those pins actually wired. For most modern needs (if "modern" can be used to apply to serial port in 2013) six wires is sufficient.

Unfortunately, there is no standard for color coding serial lines. You might hope that signal ground is black/brown, though often it is green, or some other random color. TX/RX are often yellow and green, but again you cannot count on this. The only way to know which color is connect to what pin is to test with a multimeter.